package com.whmskj.xjlhbc.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface TvLargeScreenMapper {


    List<Map<String, Object>> selectVarietiesData(@Param("classStartDate") String classStartDate,
                                                  @Param("today") String today,
                                                  @Param("month") int month,
                                                  @Param("year") int year);

    List<Map<String, Object>> selectEmployeeData(@Param("classStartDate") String classStartDate,
                                                 @Param("today") String today,
                                                 @Param("month") int month,
                                                 @Param("year") int year);

    List<Map<String, Object>> selectClassCl(String dateymd);

    List<Map<String, Object>> selectGw(@Param("today") String today,
                                       @Param("month") int month,
                                       @Param("year") int year);

    Map<String, Object> selectDh();

    Double selectZjcl(@Param("begin") String begin,@Param("end") String end);

    Map<String, Object> selectDhByDateRange(@Param("begin") String begin,@Param("end") String end);

    Double selectJscl(@Param("begin") String begin,@Param("end") String end);

    List<Map<String, Object>> selectJzkTj();

    List<Map<String, Object>> selectScrollText();
}
